CDISC Builder™  2.1 - Installation Test Scripts - %suppqual
The following documentation contains test scripts and expected results for validating the CDISC Builder tool.  Do the following to verify proper installation:
  • Start CDISC Builder application by double clicking on the desktop icon.
  • Perform each test by performing the steps specified by the instructions.  
  • Evaluate the results of each step by comparing them with results described in the Documentation column. 
Script Description Documentation
suppqual1.sas  Test the error condition of missing "Data" parameter.

Test the error condition of one level data set name.

Test the error condition where the specified data set doesn't exist.

 Instructions 1
suppqual1.log
 suppqual2.sas  Test the error condition of missing "Varname" parameter.

Test the error condition where relating record variables do not exist in the specified dataset.

 Instructions 2
suppqual2.log
 suppqual3.sas  Test the error condition of missing "StudyID" parameter. Instructions 3
suppqual3.log
 suppqual4.sas Test the error condition of missing "Usubjid" parameter. Instructions 4
suppqual4.log
 suppqual5.sas Test the error condition where variables in idvar parameter do not exist in the specified dataset. Instructions 5
suppqual5.log
 suppqual6.sas Test the error condition where parameter qorig contains invalid value.

Test the error condition where it doesn't have a one to one correspondence between VARNAME and QORIG.

 Instructions 6
suppqual6.log
suppqual7.sas Test the error condition where output parameter contains invalid value. Instructions 7

suppqual7.log
suppqual8.sas Test the error condition where basecode parameter contains invalid value. Instructions 8

suppqual8.log
suppqual9.sas Verify creating output dataset using default information.

Verify creating output dataset with specified dataset name.

Verify creating output dataset with specified library and dataset name.

Instructions 9

suppqual9.log
suppqual10.sas Verify creating output dataset where the related domain is not specified.

Verify creating output dataset where the related domain is specified.

Instructions 10

suppqual10.lst
suppqual11.sas Verify creating output dataset where the identification variable is not specified.

Verify creating output dataset where the identification variable is specified.

Instructions 11

suppqual11.lst
suppqual12.sas Verify creating output dataset where the original source of variables is not specified.

Verify creating output dataset where the original source of variables is specified.

Instructions 12

suppqual12.lst
suppqual13.sas Verify the values of QNAM, QLABEL, and QVAL in the output dataset. Instructions 13

suppqual13.lst

suppqual14.sas Verify generating basecode.sas program. Instructions 14

basecode14.sas

Instructions 1
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation "saspgm" directory.

  2. Right mouse click on the suppqual1.sas program and select "Batch Submit".

  3. Open the suppqual1.log file in a text editor.

  4. Verify that the following messages are produced.

    • ERROR: [suppqual] is missing required parameter DATA.

    • ERROR: [suppqual] "Data" parameter must be a two level dataset name.

    • ERROR: [suppqual] specified data sample.invalid does not exist.

  5. This can be verified against the suppqual1.log found in the benchmark area.

Instructions 2
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation "saspgm" directory.

  2. Right mouse click on the suppqual2.sas program and select "Batch Submit".

  3. Open the suppqual2.log file in a text editor.

  4. Verify that the following messages are produced.

    • ERROR: [suppqual] is missing required parameter VARNAME.

    • ERROR: [suppqual] INVALID variable does not exist in the dataset.

  5. This can be verified against the suppqual2.log found in the benchmark area.

Instructions 3
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation "saspgm" directory..

  2. Right mouse click on the suppqual3.sas program and select "Batch Submit".

  3. Open the suppqual3.log file in a text editor.

  4. Review the suppqual3.log file and verify that the following message is produced.

    • ERROR: [suppqual] is missing required parameter STUDYID.

  5. This can be verified against the suppqual3.log found in the benchmark area.

Instructions 4
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation "saspgm" directory.

  2. Right mouse click on the suppqual4.sas program and select "Batch Submit".

  3. Open the suppqual4.log file in a text editor.

  4. Verify that the following message is produced.

    • ERROR: [suppqual] is missing required parameter USUBJID.

  5. This can be verified against the suppqual4.log found in the benchmark area.

Instructions 5
The following instructions are accomplished through Windows Explorer.  

  1. Navigate to the validation "saspgm" directory.

  2. Right mouse click on the suppqual5.sas program and select "Batch Submit".

  3. Open the suppqual5.log in text editor.

  4. Verify that the following message is produced.

    • ERROR: [suppqual] has an invalid IDVAR specified.

  5. This can be verified against the suppqual5.log found in the benchmark area.

Instructions 6
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation "saspgm" directory..

  2. Right mouse click on the suppqual6.sas program and select "Batch Submit".

  3. Open the suppqual6.log in text editor.

  4. Verify that the following message are produced.

    • ERROR: [suppqual] has an invalid QORIG specification. 
      NOTE: valid values include: "CRF","ASSIGNED","DERIVED".

    • ERROR: [suppqual] does not have a one to one correspondence between VARNAME and QORIG.

  5. This can be verified against the suppqual6.log found in the benchmark area.

Instructions 7
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation "saspgm" directory.

  2. Right mouse click on the suppqual7.sas program and select "Batch Submit".

  3. Open the suppqual7.log in text editor.

  4. Verify that the following message is produced.

    • ERROR: [suppqual] specified library invalid does not exist.

  5. This can be verified against the suppqual7.log found in the benchmark area.

Instructions 8
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation "saspgm" directory.

  2. Right mouse click on the suppqual8.sas program and select "Batch Submit".

  3. Open the suppqual8.log in text editor.

  4. Verify that the following message is produced.

    • ERROR: [suppqual] specified base code path does not exist.

  5. This can be verified against the suppqual8.log found in the benchmark area.

Instructions 9
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation "saspgm" directory.

  2. Right mouse click on the suppqual9.sas program and select "Batch Submit".

  3. Open the suppqual9.log in text editor.

  4. Verify that the following messages are produced.

    • NOTE: [suppqual] has created the new output data: inlib.SUPPQUAL_ 
      at: c:\temp\cdiscbuilder\input 
    • NOTE: [suppqual] has created the new output data: inlib.suppqual_test1 
      at: c:\temp\cdiscbuilder\input
    • NOTE: [suppqual] has created the new output data: curdir.suppqual_ 
      at: C:\Temp\cdiscbuilder\saspgm
  5. Verify that there are two datasets which are suppqual_ and suppqual__index created in the "saspgm" directory.
  6. Navigate to the validation "data" directory.
  7. Verify that there are four datasets which are suppqual_, suppqual__index, suppqual_test1 and suppqual_test1_index created.

Instructions 10
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation "saspgm" directory.

  2. Right mouse click on the suppqual10.sas program and select "Batch Submit".

  3. Open the suppqual10.lst in a text editor.

  4. Search for the title "Related Domain was not specified" in the .lst file.

  5. Verify that the rdomain variable of the table printed with the title above has no value.

  6. Search for the title "Related Domain was specified" in the .lst file. 

  7. Verify that the rdomain variable of the table printed with the title "Related Domain was specified" contains value.

  8. This can be verified against the suppqual10.lst found in the benchmark area.

Instructions 11
The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation "saspgm" directory.

  2. Right mouse click on the suppqual11.sas program and select "Batch Submit".

  3. Open the suppqual11.lst in a text editor.

  4. Search for the title "Identification variable was not specified" in the .lst file.

  5. Verify that the idvar and idvarval variables of the table printed with the title above have no value.

  6. Search for the title "Identification variable was specified" in the .lst file. 

  7. Verify that the idvar and idvarval variables of the table printed with the title "Related Domain was specified" contain values.

  8. This can be verified against the suppqual11.lst found in the benchmark area.

Instructions 12
 The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation "saspgm" directory.

  2. Right mouse click on the suppqual12.sas program and select "Batch Submit".

  3. Open the suppqual12.lst in a text editor.

  4. Search for the title "Original source of variables were not specified" in the .lst file.

  5. Verify that the qorig variable of the table printed with the title above has only one type of value which is CRF.

  6. Search for the title "Original source of variables were specified" in the .lst file. 

  7. Verify that the qorig variable of the table printed with the title "Original source of variables were specified" contain three type of values which are CRF, ASSIGNED, and DERIVED.

  8. This can be verified against the suppqual12.lst found in the benchmark area.

Instructions 13
 The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation "saspgm" directory.

  2. Right mouse click on the suppqual13.sas program and select "Batch Submit".

  3. Open the suppqual13.lst in a text editor.

  4. Verify that the variable QNAM contains three types of value which are excat, exdosu, and  siteid.

  5. Verify that the variables QLABEL and QVAL contain the labels and values corresponding to the variable excat, exdosu, and siteid in the input dataset.

  6. This can be verified against the suppqual13.lst found in the benchmark area.

Instructions 14
 The following instructions are accomplished through Windows Explorer.

  1. Navigate to the validation "saspgm" directory.

  2. Delete dataset suppqual if any.

  3. Open the suppqual14.sas in a text editor.

  4. Modify the base code path to point to the current "saspgm" folder in you pc.

  5. Save and close the program.

  6. Right mouse click on the suppqual14.sas program and select "Batch Submit".

  7. Verify that it generates a new suppqual dataset, a suppqualindex dataset, and a basecode14.sas program in the current "saspgm" directory.

  8. Rename the suppqual dataset to supp1.

  9. Rename the suppqualindex dataset to supp1index.

  10. Right mouse click on the basecode14.sas program and select "Batch Submit".

  11. Verify that it creates two new suppqual and suppqualindex datasets in the "saspgm" directory.

  12. Open the two datasets supp1 and suppqual in either SAS Viewer or SAS System.

  13. Verify that they have the same contents.

  14. Open the two datasets supp1index and suppqualindex in either SAS Viewer or SAS System.

  15. Verify that they have the same contents.

  16. Navigate to the validation "data" directory.

  17. Create a new empty sas program named "reverse" in the "saspgm" directory.

  18. Open the basecode14.sas program in a text editor.

  19. Copy the two libname statements to the reverse.sas program.

  20. Copy the statements inside the comment block "/*** Optional code used for reverse transposition ***" to reverse.sas program.

  21. Save and close the reverse.sas program.

  22. Right mouse click on the reserse.sas program and select "Batch Submit".

  23. Verify that it re-creates a rev_suppqual_supp1_dm dataset in "data" directory.

  24. Open the rev_suppqual_supp1_dm dataset which has just been created in either SAS Viewer or SAS System.

  25. Verify that there are 4 variables in the current rev_suppqual_supp1_dm dataset which are variables specified by usubjid, idvar, and varname.

  26. Close the rev_suppqual_supp1_dm dataset and delete it from the "data" directory.

For more information, please contact MXI .

 
     Meta-Xceed Inc. © 2009